CREATE TABLE [dbo].[SuffixRef]
(
[SuffixCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SuffixRef_SuffixCode] DEFAULT (''),
[SuffixDesc] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SuffixRef_SuffixDesc] DEFAULT (''),
[SyncSuffixCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_SuffixRef_SyncSuffixCode] DEFAULT (''),
[SuffixKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_SuffixRef_SuffixKey] DEFAULT (newid())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SuffixRef] ADD CONSTRAINT [PK_SuffixRef] PRIMARY KEY CLUSTERED ([SuffixCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SuffixRef] ADD CONSTRAINT [AK_SuffixRef_SuffixKey] UNIQUE NONCLUSTERED ([SuffixKey]) ON [PRIMARY]
GO
[dbo].[SuffixRef]
